UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7RXLzTH5YVCsIQLlcQyU2Vdbl8aiKuv35KFaZGFgav8='
WHERE
key_id = '3d48e2ea87d6dac24ff53fa9713b77eac1e21948b8154ce4844da4f7aa6bf2c4'
AND (
token = '7RXLzTH5YVCsIQLlcQyU2Vdbl8aiKuv35KFaZGFgav8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)