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