UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vuv0Tj67lIa2iBFNDwSX6PRQAH7u6mTGktYesfLlaS4='
WHERE
key_id = 'ae83e18960a1b728236900f7adbc757137676e43165ed8cf8a8c3814bce8bb87'
AND (
token = 'vuv0Tj67lIa2iBFNDwSX6PRQAH7u6mTGktYesfLlaS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)