UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GC+zYQmgQnTnXXj17qBl4ABXQEICH4tJOuGZELJgyH8='
WHERE
key_id = '0c9a2687763b0a962e9712146eb5584e38cf4b67b89b012ac7994bf91095537d'
AND (
token = 'GC+zYQmgQnTnXXj17qBl4ABXQEICH4tJOuGZELJgyH8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)