UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QcNvZCnL/8SXifiQI+flX17APPF7ZNua/+uYN7ty0XM='
WHERE
key_id = 'd34ae1a8512760558a398531180db9f7454af8fa1028ea86caaa4792b521ac01'
AND (
token = 'QcNvZCnL/8SXifiQI+flX17APPF7ZNua/+uYN7ty0XM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)