UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oTXK2Zp9ByE7nFDrjW7lXTosX7ndabpJsrHG7vemMMc='
WHERE
key_id = '91d2796c7f6bd14bb690f1b44a33a847ae62ac084dcd57a67f2693b7d9482ba1'
AND (
token = 'oTXK2Zp9ByE7nFDrjW7lXTosX7ndabpJsrHG7vemMMc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)