UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1RWBobgTCfBuUL9ilcVm5vhSj3mg8AAwNiU3kTnPX90='
WHERE
key_id = '9a8a9cd9f13bcba7d369e3803e2e094353d0d29286447cfd2595db050ae1de24'
AND (
token = '1RWBobgTCfBuUL9ilcVm5vhSj3mg8AAwNiU3kTnPX90='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)