UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yuYx1EPAj7QcsWdpJ2Jba7CH7+f3nGvy84LDbtZcF30='
WHERE
key_id = '7af1fe02b9fd2d500aa929bbe05f10f76dfffcc3179c02cd9c38d5db939cc887'
AND (
token = 'yuYx1EPAj7QcsWdpJ2Jba7CH7+f3nGvy84LDbtZcF30='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)