UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BsHCogJ/7KD/r+E4R2ygFSeNDI26HrPtV8foDzGTwNA='
WHERE
key_id = 'a9002f5f2e7f7949b0238629eb71fa3906254967277faa5de69b6d0d11525e79'
AND (
token = 'BsHCogJ/7KD/r+E4R2ygFSeNDI26HrPtV8foDzGTwNA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)