UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XY0qyMywoxhS8u1F851UcoCKm4Mr4caaPbxV4nkpM4E='
WHERE
key_id = '288129a514abcbc29d7b54e866898aeed7dbfdff199d27cb7e47edc49ae38da4'
AND (
token = 'XY0qyMywoxhS8u1F851UcoCKm4Mr4caaPbxV4nkpM4E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)