UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/+4LS50uqYalPtjPABJOArW/brSBKPBxdZiyLOiqw1U='
WHERE
key_id = 'beb8c090111c62a4deaa2a2ef43160ef4561a818a0017206368aca3d1ce496c0'
AND (
token = '/+4LS50uqYalPtjPABJOArW/brSBKPBxdZiyLOiqw1U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)