UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zs7D6eTC1BvhfwxQfQr8bUASFxVZnRsgeb2LkPMfVgg='
WHERE
key_id = '8b64689d440a837228a052d83c2e35759e225ada37b2e6ae1f1241a4051bf584'
AND (
token = 'zs7D6eTC1BvhfwxQfQr8bUASFxVZnRsgeb2LkPMfVgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)