UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WaCS/9ZbcWaI9qSTvVCAX2heSbnK57M/xNVX7D3r87A='
WHERE
key_id = '7f4d9f4bc9bc97e8a91d4ad57cfa3f4205bafb2fbc40fe785cbb740210185c2a'
AND (
token = 'WaCS/9ZbcWaI9qSTvVCAX2heSbnK57M/xNVX7D3r87A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)