UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p7kGXNV50F4mSv2Qts/q+RfcgdK8GBKzyTLGYJok2go='
WHERE
key_id = '916b058481ee34c91b24e374cc55bed3023fa21ed3e6ce94cff318c538721909'
AND (
token = 'p7kGXNV50F4mSv2Qts/q+RfcgdK8GBKzyTLGYJok2go='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)