UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C6fgCGM190+tZq38R0C7nwWQrRLkiABYtPX956FoLpw='
WHERE
key_id = 'b98b906628fccc829b9b6abd51bbd215835e6df26e095d2f0946c46e9050ac1c'
AND (
token = 'C6fgCGM190+tZq38R0C7nwWQrRLkiABYtPX956FoLpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)