UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VvK3APSq8v5WPXjw/zX9lUfKXTHbME09w5BVf6SYoes='
WHERE
key_id = '747490571791322a9535dd51aa74bcda0e3af0f976debf19b45e9ca79453902b'
AND (
token = 'VvK3APSq8v5WPXjw/zX9lUfKXTHbME09w5BVf6SYoes='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)