UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cgRmjpf0NltOTuta3SI9BvC4Kvcdjc6a5uwCckxkHl0='
WHERE
key_id = '7a9bb1c5d35b878a2f841dfb8a623aaf5d8f3413ec1f001c58b31f65413b2878'
AND (
token = 'cgRmjpf0NltOTuta3SI9BvC4Kvcdjc6a5uwCckxkHl0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)