UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CCBFyGkT9dCi6A6lkkCeUU02AHijpmpwh7r7c0VQJMM='
WHERE
key_id = '5b51dd018a5c2773778eda77ce3c3e10f95c85528da177022360bb08c973efec'
AND (
token = 'CCBFyGkT9dCi6A6lkkCeUU02AHijpmpwh7r7c0VQJMM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)