UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n5zOXmDLF2OQ7hHFivW7YSBM42pbWCNCHTyGH4saBsk='
WHERE
key_id = 'cf24d425c9b1b8f2d4637d6235fb4fc32bb5a680400bf2cafa27625430df5959'
AND (
token = 'n5zOXmDLF2OQ7hHFivW7YSBM42pbWCNCHTyGH4saBsk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)