UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'roUAaxs+XIwsBQeSx8vGGB6rabOrXPkFcfX0UvQwhnE='
WHERE
key_id = 'd57db29d243b43b3628d431a042d59b850259cea4fb2a0cd52d72d0292274043'
AND (
token = 'roUAaxs+XIwsBQeSx8vGGB6rabOrXPkFcfX0UvQwhnE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)