UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/fn2spBaWOhcoWkiKBor0qg1d+a/UqBp+vHrA8dsHX0='
WHERE
key_id = '1be0925824d1317972c11c173bd80a3318ed38fa44028cf27f1f815350932a9a'
AND (
token = '/fn2spBaWOhcoWkiKBor0qg1d+a/UqBp+vHrA8dsHX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)