UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mN0fKv0PJnu0o2aMf+cScahfEJQJlJHHXEnNJFYoqaw='
WHERE
key_id = '897e9f5663848951b1f2a378b99a10f34c7e4d180bb1637134df4928e3e2cc1b'
AND (
token = 'mN0fKv0PJnu0o2aMf+cScahfEJQJlJHHXEnNJFYoqaw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)