UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c3XtztMCN6hA3dcUhMnJCnIyzN3kc1z2zAvRmj6e4rg='
WHERE
key_id = '32ad5b45f49a1cc2210805d451d9496bd4b35d10349117ca2689ec15c518237c'
AND (
token = 'c3XtztMCN6hA3dcUhMnJCnIyzN3kc1z2zAvRmj6e4rg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)