UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B9KicJuEn2zv5t7Uf2bVRUGUvchZv7S7bRaZf1eV2xE='
WHERE
key_id = '6ea2cee748a54f324ec2b1836223ad884ec8305db6a3e1b3811800d045770a02'
AND (
token = 'B9KicJuEn2zv5t7Uf2bVRUGUvchZv7S7bRaZf1eV2xE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)