UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XcPo03RIZ+LnGj1hTuf+WuSObjvENqFTVu15ZfWl4x0='
WHERE
key_id = '5d856d58bb2f7bde364944ebb98b1213be31fee4e3a7be8d00165dbddc2926d6'
AND (
token = 'XcPo03RIZ+LnGj1hTuf+WuSObjvENqFTVu15ZfWl4x0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)