UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L5IdBz5iv7DmbbatkWkNWh730pzdMxwjRTcXAG1fPOo='
WHERE
key_id = '33c2763fb46a415ce085a4d75767a152e01627199bdd6d6eff0eca992b7b8b6f'
AND (
token = 'L5IdBz5iv7DmbbatkWkNWh730pzdMxwjRTcXAG1fPOo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)