UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RcR60m1PJvEpyRiqcyVnnQ3Pfv86BFWw29wij2W/dIU='
WHERE
key_id = 'f9cdabb7ac8b12b61f6ddae8163cdacbb2d268f7298817e10cc27e25a91f94ba'
AND (
token = 'RcR60m1PJvEpyRiqcyVnnQ3Pfv86BFWw29wij2W/dIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)