UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wfpgjLqQKPgriDQusNvxjUSWXR1nquLqWvqm/8IpgUY='
WHERE
key_id = 'cc4bc9ed4405aad6ab2847ed324f2857dcbfea9b8c085f41bfbdf318e6a979ac'
AND (
token = 'wfpgjLqQKPgriDQusNvxjUSWXR1nquLqWvqm/8IpgUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)