UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5BH1zdYj1QZ3fAXSl90UUwa+hc97IrJsBR/rON0Tg7g='
WHERE
key_id = '00f999315b0ae7776d1e2cea070258786781d5e1265081dc9d06e08ee3c0124f'
AND (
token = '5BH1zdYj1QZ3fAXSl90UUwa+hc97IrJsBR/rON0Tg7g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)