UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VjBPrI/EbGwGQyPEvgYFU8LRE9XYjluc+dK9Bd5elC8='
WHERE
key_id = 'fb5ff64dccab05d3ed3a81f59d103ff9702212a9e40cf57fbfd4cb5fc95d3203'
AND (
token = 'VjBPrI/EbGwGQyPEvgYFU8LRE9XYjluc+dK9Bd5elC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)