UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KhcdtZl8rojagWsHXop2/J2mna/ihTCAK3thV/sKc50='
WHERE
key_id = '2df5306a9062aec47e9403e998c6728f769475bbcd231c9a0edc8c91686d3dc5'
AND (
token = 'KhcdtZl8rojagWsHXop2/J2mna/ihTCAK3thV/sKc50='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)