UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5GGf7wEC7E6iyZLuj2d0PFavosZVX3aVDWBSgLEFOPA='
WHERE
key_id = '504c34075963d9e5d5516dd99bb1b2ea53040967463fc713117794b1d55312e1'
AND (
token = '5GGf7wEC7E6iyZLuj2d0PFavosZVX3aVDWBSgLEFOPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)