UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zLMBVHNklxOcLh748UjdIJJe0helog5Jgs3KPlt6bZM='
WHERE
key_id = 'dea23cd72dcec509e50a79ecfe379fdb030c1566c3d0c3a86aaf802335602f28'
AND (
token = 'zLMBVHNklxOcLh748UjdIJJe0helog5Jgs3KPlt6bZM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)