UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6rKxwixWefNeZZJCHlD6RmMzT+dRXvmg8bwCaTOd4ak='
WHERE
key_id = '0c7968213dbd1d2900211330647118a99f7212d04cd329e35e3afbc738585d70'
AND (
token = '6rKxwixWefNeZZJCHlD6RmMzT+dRXvmg8bwCaTOd4ak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)