UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R0a5X9nST+bUuJZBYD7uagRshqKHtJ8LYD6xSNJHv18='
WHERE
key_id = '58f4621c49b7bee7bb375b3afed63ec4544530c69c7d5b20db05bf008b652167'
AND (
token = 'R0a5X9nST+bUuJZBYD7uagRshqKHtJ8LYD6xSNJHv18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)