UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QIPNN0H5ExiZH8WdpiESZS924n3T8ewAXSwoPu/TKUg='
WHERE
key_id = 'b6a6eac4caa111644aa7a1927860c89a7ce4afaa34dfe07f9c6a72b839a497b1'
AND (
token = 'QIPNN0H5ExiZH8WdpiESZS924n3T8ewAXSwoPu/TKUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)