UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oJuBtJW55Q1LUkpHJsXmNPMVWpBtJ/b5VmpNSQs2Ii4='
WHERE
key_id = 'fb2bc0e8fa37beccec83e4f1e979ea366e249d2658d9089849a36a8ec49ed300'
AND (
token = 'oJuBtJW55Q1LUkpHJsXmNPMVWpBtJ/b5VmpNSQs2Ii4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)