UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zBvgDSrd19xAKOdBa5JL3qyIyV+Yqej8WUBCC8DqcmQ='
WHERE
key_id = 'c14a776b4794458f49a29b2b427922067bf219ddc780c79554b87309c315eab7'
AND (
token = 'zBvgDSrd19xAKOdBa5JL3qyIyV+Yqej8WUBCC8DqcmQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)