UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6vghBTMVU78S53dSnF1FDtiwUkKKy//QDiYC3xruwxU='
WHERE
key_id = 'af16980fba1725b1f98c0b2293acedbe0634b714c95b0a9b3dc7405023f26a91'
AND (
token = '6vghBTMVU78S53dSnF1FDtiwUkKKy//QDiYC3xruwxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)