UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L6QYT24L+tmLS7ieJZCQxCQjVcSNUF4xou9AKHo16jk='
WHERE
key_id = 'c3d6275d4caf7051c1bdcac777789f60fa13d36a9baae303de029e1580d2a995'
AND (
token = 'L6QYT24L+tmLS7ieJZCQxCQjVcSNUF4xou9AKHo16jk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)