UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tXxfPWCCr64BzNBkTzy8WGFmZhQhAU4U8w6KvNhcVfU='
WHERE
key_id = '402887dd6217745ec89aca67ae49e18747f625d7f5e2251cd157def2ec08144b'
AND (
token = 'tXxfPWCCr64BzNBkTzy8WGFmZhQhAU4U8w6KvNhcVfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)