UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aBp1nPUc6WXmf3y8T+a7pvv98a6JYYFUEYJHZAJ+/fw='
WHERE
key_id = '42b5c96d74377ef82bd6e3ce0cbba42b830e08054e304faa2cb0046c76ee59dd'
AND (
token = 'aBp1nPUc6WXmf3y8T+a7pvv98a6JYYFUEYJHZAJ+/fw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)