UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4Ih0LoDCHmQ3vxZc8NRyulfqIy8aUuOe0VvgjwlqOSA='
WHERE
key_id = '244a2e9883b3cf30b70e0cbdf1a1b4ce240e3bb65eb3bb00fd4dd25ff3813ef6'
AND (
token = '4Ih0LoDCHmQ3vxZc8NRyulfqIy8aUuOe0VvgjwlqOSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)