UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/z4EA40tW4AT4BHEhkp4NGXiG27D5e7MB0BN8bxVauY='
WHERE
key_id = '98d81def176d310a62654f2bda6e0a4cbf5f0e2018e758d87d862d7137c01c2d'
AND (
token = '/z4EA40tW4AT4BHEhkp4NGXiG27D5e7MB0BN8bxVauY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)