UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oagUXwoO+UOvpOJW0DYqhHzkRrwaJj29XIwhwhB1G+w='
WHERE
key_id = '49a21e48d51648104b2888c149696328d8bb7a64f74b3062bfdd3bbb79caabc8'
AND (
token = 'oagUXwoO+UOvpOJW0DYqhHzkRrwaJj29XIwhwhB1G+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)