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