UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VBFlT1Hwj3Vy+wqw8aVblVb8kbCSNEEXX5U1L/Se/zk='
WHERE
key_id = 'ee0f46ec756a1081ec4e95250e1f8f70841a51b9f1d678f351b6ff56f89b9bbf'
AND (
token = 'VBFlT1Hwj3Vy+wqw8aVblVb8kbCSNEEXX5U1L/Se/zk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)