UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CTYU9gO+wxqvD3RwtZdOo1kHmMWY33dwpAyZupdmj/o='
WHERE
key_id = '4713f7a0184d286c73f8fa6c46637800fb749ea46d779f3398f8b8d086cae2f0'
AND (
token = 'CTYU9gO+wxqvD3RwtZdOo1kHmMWY33dwpAyZupdmj/o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)