UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '99QITUX30oXYn09iLcj/onSce11jRsw1vQ4gM9/VI00='
WHERE
key_id = 'd6bca9f96de2b856c5ebbbc8c63e2e025aa0c8b37f909c033cdbdf1dd70b0429'
AND (
token = '99QITUX30oXYn09iLcj/onSce11jRsw1vQ4gM9/VI00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)