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