UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v23ZsDfaYC29xlRCTuoDT1FdEQvIktCV/nqZrr2PUs8='
WHERE
key_id = 'cfdd162d99d6d11b9adb1f01005137f8ab9ab51ad38e72df3845fdbd75df5451'
AND (
token = 'v23ZsDfaYC29xlRCTuoDT1FdEQvIktCV/nqZrr2PUs8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)